Metadata for Montana Food Establishments, 2013

• Identification Information
• Data Quality Information
• Spatial Data Organization Information
• Spatial Reference Information
• Entity and Attribute Information
• Distribution Information
• Metadata Reference Information


• Download full XML Metadata

---

Identification Information:

Citation:

Originator: Montana State Library

Publication date: 07/19/2013

Title: Montana Food Establishments, 2013

Publisher: Montana State Library

Online linkage: https://ftpgeoinfo.msl.mt.gov/Data/Spatial/NonMSDI/Food_Infrastructure_2013.zip

Abstract:

This layer was designed to contain records for establishments in Montana that serve or produce food. The primary sources of records were a spreadsheet provided by the Montana Department of Public Health and Human Services that listed all of the establishments in Montana that have licenses to serve or sell food, and lists of establishments engaged in local commerce provided by the Montana Alternative Energy Resources Organization (AERO). The data were available from May 2012 through December 2015 as an ArcGIS Online map published by the State Library.

The coordinate locations of the records come from a variety of sources. The primary method for geo-locating the records was automatic geocoding of their addresses. Most of the establishments that have been identified as being engaged in local commerce have had their locations examined by hand and the locations have been adjusted to try to place them on the correct building identifiable on aerial photos. The layer has attribute fields that specify how the locations were established.

Some of the establishments have a latitude and longitude coordinate of -1.0,1.0. These are establishments whose locations could not be determined.

The layer is stored in the Web Mercator coordinate system to improve peformance with ArcGIS Online. Desktop GIS software typically cannot portray data in this coordinate system at the correct map scale. The data should be projected to a coordinate system appropriate for use in Montana before being used with desktop GIS software.

Purpose:

These data were produced to support a project to map all of the establishments in Montana that engage in local commerce, that sell or process locally-produced food, or that are food producers that sell their food to local processors, retail outlets, or customers. The data contain every establishment in Montana that has a license to sell food and all food producers the project participants knew of that were engaged in local commerce.

The layer is intended to be used with a related table that cross-references between the establishments and the functions (Such as "beef producer", "grocery store", "restaurant") that the establishments provide. The ID_Num field is the link to the Functions table.

The Functions table in the same geodatabase contains the ID_Num field and a Code field. The Code field refers to function or product names in the Function_Codes table in the geodatabase. There is one record for each function or product provided by each establishment, so one establishment may appear several times in the table, once for each function or product that it provides. The Function_Locations layer in the geodatabase is produced by linking the Functions table to the Establishment_Locations feature class table. To re-create the Function_Locations layer, the geodatabase tables must be moved to a database with full support for SQL queries and the following query must be run. This will create an table whose latitude and longitude fields may be used to create an event layer that may be exported as a GIS layer.

SELECT Establishment_Locations.Establishment, Establishment_Locations.Address,
Establishment_Locations.City, Establishment_Locations.ZIP,
Functions.Code AS Function_Code, Function_Codes.Type_ AS Function_Name,
Food_Status_Codes.Explanation AS Status, Functions.ID AS Function_ID,
Establishment_Locations.ID_Num AS Establishment_ID,
Establishment_Locations.County,
Establishment_Locations.Latitude, Establishment_Locations.Longitude
FROM Functions
INNER JOIN Function_Codes ON
Function_Codes.Code = Functions.Code
INNER JOIN Establishment_Locations ON
Functions.ID_Num = Establishment_Locations.ID_Num
INNER JOIN Food_Status_Codes ON
Establishment_Locations.Status = Food_Status_Code.StatusID
WHERE (NOT (Establishment_Locations.Latitude IS NULL))

Time period of content:

Beginning date: 01/01/2011

Ending date: 07/19/2013

Currentness reference: Ground Condition

Access constraints: None

Use constraints:

This layer is stored in the Web Mercator coordinate system to improve peformance with ArcGIS Online. Desktop GIS software typically cannot portray data in this coordinate system at the correct map scale. The data should be projected to a coordinate system appropriate for use in Montana before being used with desktop GIS software.

The Montana State Library provides this product/service for informational purposes only. The Library did not produce it for, nor is it suitable for legal, engineering, or surveying purposes. Consumers of this information should review or consult the primary data and information sources to ascertain the viability of the information for their purposes. The Library provides these data in good faith but does not represent or warrant its accuracy, adequacy, or completeness. In no event shall the Library be liable for any incorrect results or analysis; any direct, indirect, special, or consequential damages to any party; or any lost profits arising out of or in connection with the use or the inability to use the data or the services provided. The Library makes these data and services available as a convenience to the public, and for no other purpose. The Library reserves the right to change or revise published data and/or services at any time.

Point of contact:

Montana State Library

PO Box 201800

Helena, MT 59620-1800

Telephone: 406-444-5354

TDD/TTY telephone: Montana Relay 711

E-Mail: geoinfo@mt.gov

Back to Top

---

Data Quality Information:

Completeness report:

This layer contains all establishments that had a license to sell or process food from the Montana Department of Health and Human Services. It contains various establishments that grow food, but none of the sources is a comprehensive database and the layer contains a very small subset of all the farms and ranches in Montana which were known to the project participants.

Lineage:

Process step:

Between Sep 9 2011 and October 24 2011 I familiarized myself with the project and with the data NRCS and MSU had initially provided. During this time, we received a spreadsheet from DPHHS listing all of the establishments in Montana that have licenses to serve food.

On October 17 the project partners met and talked about ideas for how GIS could help them. We decided to do a pilot project to map the locations and functions of all the businesses in Lake, Missoula, Ravalli, Flathead, and Sanders counties.

Between November 11 and November 14 I combined all the establishments from the various tables and layers into a single table, tried to identify duplicate records, and added fields to the table to track which tables each record came from. On November 14 the partners met and created a list of function codes that could be assigned to each establishment and agreed that the records for the 5-county pilot project would be divided between the participants. I would send them each a pair of spreadsheets to record the functions of each business. I sent out the spreadsheets on November 18.

By November 28 I had all of the spreadsheets back and entered the data in the Functions table. Between then and December 1 I ran the establishment database through the Montana address matching service to create a spatial layer, worked on mapping locations of the un-matched records, especially in Lake County, and made the maps of the function locations for the 5 Valleys meeting in Arlee on December 2.

We received a litte bit more data at the Arlee meeting and I entered it into the database. The partners met on December 15 and decided I would create a web application for the partners to use to input functions for the establishment database and that this would be available around the state for knowledgeable people to update. The application was finished on January 12 and Login IDs and instructions for participants were sent out on about the 20th.

On January 19 I worked out a way to let an person work with Google Earth to specify locations for the establishments that failed their address-matching. An intern received instructions for this on February 1. I received 183 records from the intern between February 22 and 28, at which point she said she had completed her assigned 20 hours of work.

AERO sent me spreadsheets with between 150 and 200 establishments on March 5. On March 6, I compared the establishment names in the spreadsheets to the existing records in the database and made some corrections to the existing data where I thought the new data looked correct. For each new record in the new table, I assigned a new establishment ID. I set the status equal to 2 for all the records and one of the table columns to "Aero_20120305", except where all 6 columns were already full. The spreadsheet contained a list of function codes for each record, and I added these to the functions table.

AERO sent more spreadsheets on March 14 and April 2 and I added them to the database. Several records were updated via the web form between March 15 and April 5. On April 6 I ran all the new records through the ITSD geocoding service and added the results to the main SQL server table.

AERO decided to have a volunteer locate more establishments whose address matching had failed, with priority on records that had been identified as being engaged in local commerce and secondary priority on records from the JSU tables that did not have good locations. On April 9 I prepared two tables containing 260 priority and 283 secondary records and delivered them to AERO.

AERO worked out a method for loading this data into Google Fusion Tables and saving the address-matched locations as kml files. We had a lot of trouble getting Google Earth to actually save the latitude and longitude coordinates into the kml file instead of just the addresses, but I think I eventually got all the locations, finishing around April 30. The volunteer did NOT try to find any of the establishments on the air photo, she just worked to find better addresses for records that didn't get geocoded. Google geocoded a lot more addresses than the ESRI locators did.

In May 2012 AERO sent a few more data updates. On about June 6 time I loaded the database into an ArcGIS Server service and developed an on-line map of the database at arcgis.com to allow anyone to browse the database. The current location of this map is here or it may be found by going to http://www/arcgis.com/home and searching for "Montana food infrastructure".

In June AERO provided a few more database updates and had someone use the on-line forms to update certain things, such as all the Hutterite Colonies. They asked me to make sure we had good locations for all the colonies, and that all the colonies were in there. I spent quite a lot of time on this, using http://www.cedrontech.com/hutterite.aspx?idx=MT as a source.

In early July I made some database updates requested by AERO.

On September 18 I made database updates requested by AERO.

Back to Top

---

Spatial Data Organization Information:

Point and vector object information:

SDTS object type: Entity point

SDTS object count: 9663

Back to Top

---

Spatial Reference Information:

Horizontal coordinate system definition:

Map projection:

Map projection name: WGS 1984 Web Mercator Auxiliary Sphere

Map projection parameters:

WGS 1984 Web Mercator Auxiliary Sphere

Other projection's definition:

PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3857]]-20037700-3024110010000-10000010000-100000100000.0010.0010.001true1021003857

Planar distance units: meter

Geodetic model:

Horizontal datum name: D WGS 1984

Ellipsoid name: WGS 1984

Semi-major axis: 6378137.0

Denominator of flattening ratio: 298.257223563

Back to Top

---

Entity and Attribute Information:

Entity type label: Establishment_Locations

Entity type definition: Attributes of Establishment_Locations

Attribute label: OBJECTID

Attribute definition: Internal feature number

Attribute label: Shape

Attribute definition: Feature geometry

Attribute label: ID_Num

Attribute definition:

Establishment ID number. This field is used to link establishments to the table that lists the functions each establishment provides.

Attribute label: Establishment

Attribute definition: This is the name of the establishment.

Attribute label: Status

Attribute definition: Code for the local commerce status

Attribute Value Definition of Attribute Value -1 No attempt has been made to determine the status of the establishment. 0 The data reviewer was unable to determine the status of the establishment. 1 The establishment does not buy local food or sell locally-produced food to local establishments or customers. 2 The establishment buys or sells locally-produced food. 3 The establishment possibly buys or sells locally-produced food. 4 The establishment is a type of business that was not to be examined in the study.

Attribute label: Address

Attribute definition: Street or mailing address

Attribute label: City

Attribute definition: City, part of the the mailing address

Attribute label: ZIP

Attribute definition: ZIP Code, part of the mailing address

Attribute label: County

Attribute definition: County that the establishment is in

Attribute label: Table1

Attribute definition:

Identifier of a source that provided information about the establishment.
This is the primary source of this record. Many establishments were available from several sources, and the additional sources are listed in the Table2 through Table6 fields.

Attribute Value Definition of Attribute Value 5 Valleys Summit Attendees of the 5 Valleys Summit meeting in Arlee on 12/2/2011. AERO_MT Records provided by the Alternative Energy Resources Organization at the beginning of the project. AERO Values that contain AERO refer to data that were provided at various times during the project by the Alternative Energy Resources Organization. Abundant_MT Shapefile derived from the Abundant Montana member list and the Montana Cadastral database. Cherry_Survey_Grocer Grocery stores from a survey of the Montana Cherry Growers DPHHS_Food Montana Department of Public Health and Human Services list of licensed food establishments DPHHS_Hotel Montana Department of Public Health and Human Services list of hotels with food serving licenses DPHHS_Wholesale Montana Department of Public Health and Human Services list of licensed food wholesalers FarmersMkt Shapefile of farmers markets, list assembled by AERO from Abundant Montana, Yummy MT, and Montana Department of Agriculture records. Locations were extracted from the Montana Cadastral database. MSUAltFoodOutlet Alternate food outlet locations from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program. MSUCharity Charitable organizations that distribute food, from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program. MSUCommGarden Community gardens from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program. MSUCommSupGard Community support gardens from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program. MSUConvenienceStore Convenience stores from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program. MSUFarmDirectWIC Farmers who sell directly to the Women, Infant, and Children Supplemental Nutrition Program, from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program. MSUFarmersMkt Farmers markets from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program. MSUGrocery Grocery stores from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program. MSUPublicTrans Public transportation companies from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program. MSUSchoolGarden School gardens from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program. MT_CSA Community Supported Agriculture entities from Abundant Montana MT_Canning_Processin Canning and processing plants provided by the Natural Resources Conservation Service MT_Certified_Organic Certified organic producers from the Montana Organic Program MT_Custom_Meat - MT_Inspected_Meat - MT_MPI_All_Meat Montana meat and poultry inspection bureau meat packing sites MT_Meat_Depot - MT_Poultry_Growers - US_Inspected_Meat - US_Organic_Producers National Organic Producers dataset from the U.S. Department of Agriculture. Western_MT_Growers - cedrontech.com This was a web site with a list of Montana Hutterite colonies.

Attribute label: Table2

Attribute definition:

Identifier of a source that provided information about the establishment

Attribute label: Table3

Attribute definition:

Identifier of a source that provided information about the establishment

Attribute label: Table4

Attribute definition:

Identifier of a source that provided information about the establishment

Attribute label: Table5

Attribute definition:

Identifier of a source that provided information about the establishment

Attribute label: Table6

Attribute definition:

Identifier of a source that provided information about the establishment

Attribute label: Edited_By

Attribute definition:

Code for the person who edited the record local commerce status or functions

Attribute Value Definition of Attribute Value 107 Gerry Daumiller 204 Nancy Matheson 301 Alison Harmon 302 Colin Waters 303 Kevin Moore 304 Karl Sutton 305 Mary Stein 306 Sandy Courtnage 310 Lyra Leigh-Nedbor 312 Alyssa Charney 313 Erin Janoso 314 Leah Grunzke

Attribute label: Edited_Date

Attribute definition: Date when the local commerce status or functions were edited

Attribute label: Loc_name

Attribute definition:

Name of the resource or person that the data location is from.

The value may be a combination of a person and a resource, or a date and a resource, or just a resource. Values that contain a month and day, such as "4-27 exact" were entered by Janet Hess-Herbert at AERO and contain information about which Google locater level was obtained. Janet also used Google address locations for records that have her name or Google and a match level in the field. Records that have a person's name, Cadastral, or NRIS in them were located by hand. These are mostly records for establishments which were known to participate in local commerce and for which good locations were not obtained from the MSU databases or from ESRI address-matching. If these values have question marks in them, they indicate that the person who entered them had a poor degree of confidence that they had identified the correct location.

If the value contains MSU, the location is from one of the Montana State University layers.

If the field is blank, no location is known for the record and its coordinate has been set to -1,1.

Records that were automatically located using the record street address and a geocoding service have the values listed in the enumerated domain.

Attribute Value Definition of Attribute Value ESRIMTStreets The location is interpolated along a street segment in the ESRI street database whose address range matched the establishment address. MTRoadsWAddrs The location is interpolated along a street segment in the Montana Transportation Framework database whose address range matched the establishment address. MTStructures The location is the point location of a structure in the Montana Structures Framework whose address matched the establishment address. MTZipCodes The location is on the centroid of the zip code indicated in the establishment address. No address in the locator databases matched the establishment address.

Attribute label: Score

Attribute definition:

0-100 quality of the address match with a locator. Records that only matched the ZIP code have a score of 100.

Attribute label: Match_type

Attribute definition: Unknown. The Match_type is always either blank, or "A".

Attribute label: Match_addr

Attribute definition:

Value from the locator address database that the locator used to place the location.

Attribute label: Table_ID

Attribute definition: ID number from the source table for the record

Attribute label: Owner

Attribute definition: Name of the establishment owner

Attribute label: Parent_ID_Num

Attribute definition:

Early in the project there was an effort to preserve the relationship between duplicate records. If the parent_id_num is not the same as the id_num, a duplicate record was deleted.

Attribute label: Latitude

Attribute definition: Latitude of the establishment location

Attribute label: Longitude

Attribute definition: Longitude of the establishment location

Attribute label: Loc_Class

Attribute definition: Classification of the method used to determine the location.

Attribute Value Definition of Attribute Value Address The location is at a street address from the Montana Base Map Service Center ESRI geocoding service. City Level The location is at a town centroid from the Google geocoding service. Google The location is at a street address from the Google geocoding service. Hand-Estimate The location was placed by hand, with the person who selected the location indicating lack of confidence that the correct location was known. Hand-Placed The location was placed by hand and the person who selected the location was confident it was correct. MSU The location came from an MSU spatial layer. ZipCode The location is at a Zip Code centroid. blank The location is unknown, with the coordinate set to -1,1.

Entity type label: Functions

Entity type definition: List of establishment functions and their code values.

Attribute label: Code

Attribute definition:

Code for an establishment function. The codes are heirarchical. The first two digits refer to a general class of products or functions, the second two digits refer to a sub-category, and the last two digits are more specific. Project editors were instructed to be specific as possible and to not enter both a general class and a more specific instance of that class for the same establishment, but they did not always follow these instructions.

Attribute Value Definition of Attribute Value 100000 Producer (farm/ranch) 100100 Produce (vegetables, fruit) 100101 Vegetables 100102 Fruit 100103 Tree Fruit 100200 Dairy 100300 Eggs 100400 Poultry (chickens, turkeys, ducks) 100500 Livestock 100501 Cattle 100502 Hogs 100503 Sheep/Lambs 100504 Other (Bison, Goats, etc) 100700 Fish/aquaculture 100800 Nursery (bedding plants for transplanting) 101100 Cereal grains 101200 Oilseeds 101300 Pulses 101400 Apiary/Honey 200000 Feedlot 300000 Food Manufacturer 300100 Flour miller 300200 Oilseed processor 300300 Pulse processor 300400 Sugar processor 300500 Co-packer (custom processing of others' products) 300600 Produce processor (fruit and vegetables, preserves, salsa) 300700 Dairy processor (milk, butter, cheese, yogurt, ice cream) 300701 Grade A dairy products 300702 Grade B dairy products 300800 Poultry plant, exempt 300801 Poultry plant, State-inspected 300900 Meat processor 300901 Custom exempt 300902 State inspected 300903 Federally inspected 300904 Slaughter 300905 Packing/processing 300906 Red meat 301000 Confectionery/Syrup/Jam 301100 Bakery 301200 Beverages 301201 Beer/Wine 301202 Fruit juice 301203 Other Beverages 301300 Other (snacks, supplements, etc.) 400000 Wholesale Food Distributor 400100 Broker 400200 Transporters/Freight hauler 500000 Retail Food Distributor 500100 Farmers Market 500200 CSA 500300 Farm Stands/U-Pick 500400 Grocer 500401 Montana independent or chain 500402 National/regional supermarket chain 500500 Convenience Store 500600 Food Service 500601 Restaurant, hotel, Bed and Breakfast, guest ranch 500602 Institutional cafeteria/food service 500603 School K-12 500604 College/university 500605 Early childhood care/educ. 500606 Retirement/nursing home 500607 Hospital 500608 Prison/jail 500609 Caterer 500610 Bar 500700 Charitable Outlet (food pantry/bank) 600000 Non-Food 600100 Flowers

Back to Top

---

Distribution Information:

Distributor:

Montana State Library

PO Box 201800

Helena, MT 59620-1800

Telephone: 406-444-5354

TDD/TTY telephone: Montana Relay 711

E-Mail: geoinfo@mt.gov

Resource description: Downloadable Data

Distribution liability:

The Montana State Library provides this product/service for informational purposes only. The Library did not produce it for, nor is it suitable for legal, engineering, or surveying purposes. Consumers of this information should review or consult the primary data and information sources to ascertain the viability of the information for their purposes. The Library provides these data in good faith but does not represent or warrant its accuracy, adequacy, or completeness. In no event shall the Library be liable for any incorrect results or analysis; any direct, indirect, special, or consequential damages to any party; or any lost profits arising out of or in connection with the use or the inability to use the data or the services provided. The Library makes these data and services available as a convenience to the public, and for no other purpose. The Library reserves the right to change or revise published data and/or services at any time.

Back to Top

---

Metadata Reference Information:

Metadata date: 11/17/2015

Metadata contact:

Gerry Daumiller

Montana State Library

PO Box 201800

Helena, MT 59620-1800

Telephone: 406-444-5354

TDD/TTY telephone: Montana Relay 711

E-Mail: geoinfo@mt.gov

Back to Top